unit unit_GenesisDBConsts;

interface
uses
  DB,
  unit_DBStructure;
const
//
// Genesis table data
//
GenesisTableFields: array [1 .. 6] of TFieldDesc = (
  (Name: 'ID';           DataType: ftInteger;    Size: 0;   Required: true),
  (Name: 'Filename';     DataType: ftWideString; Size: 255; Required: false),
  { TODO -oAdministrator -c : field FileSize must be ftLargeInt 11.08.2010 19:05:35 }
  (Name: 'Filesize';     DataType: ftLargeint;   Size: 0;   Required: true),       //ftLargeInt
  (Name: 'IsLocal';      DataType: ftBoolean;    Size: 0;   Required: false),
  (Name: 'MD5';          DataType: ftString;     Size: 32;  Required: true),
  (Name: 'CRC32';        DataType: ftString;     Size: 8;   Required: false)
);
//
GenesisTableIndexes: array [1..5] of TIndexDesc = (
  (Name: 'ID_Index';     Fields: 'ID';         Options: [ixPrimary, ixUnique]),
  (Name: 'FileName_Index'; Fields: 'Filename'; Options: [ixCaseInsensitive]),
  (Name: 'FileSize_Index'; Fields: 'FileSize'; Options: [ixCaseInsensitive]),
  (Name: 'MD5_Index';      Fields: 'MD5';      Options: []),
  (Name: 'IsLocal_Index';  Fields: 'IsLocal';  Options: [])
);
implementation

end.
